ODBC Driver for MySQL and MariaDB

Devart ODBC Driver for MySQL is a high-performance connectivity solution with enterprise-level features for accessing MySQL, Microsoft Azure Database for MySQL, MariaDB, Amazon RDS for MySQL, and Amazon Aurora databases from ODBC-compliant reporting, analytics, BI, and ETL tools on both 32-bit and 64-bit Windows, macOS, and Linux. Devart ODBC Driver fully supports standard ODBC API functions and data types and enables straighforward and secure access to live MySQL data from anywhere.

More ODBC Drivers

Direct ODBC Connnection to MySQL and MariaDB

Our data connector enables various ODBC-aware applications to establish a direct connection to MySQL via TCP/IP to eliminate the need for MySQL client. A direct connection increases the speed of data transmission between an external application and MySQL for real-time analytics. It streamlines the deployment process, since there is no need to distribute any additional client-side software with the ODBC driver for MySQL.

What are some reasons to choose Devart ODBC Driver for MySQL?

Integration

The driver is compatible with third-party tools for data analysis, such as Microsoft Excel, and integrates with various IDEs and systems like Visual Studio, DBeaver, etc.

For the complete list of compatible tools and environments visit the Compatibility page.

Platforms Variety

ODBC Driver for MySQL can be used with 32-bit and 64-bit applications on both x32 and x64 platforms, so there is no need to additionally configure the driver, applications or environment.

Fully Unicode-Compliant Driver

With our fully Unicode-compliant driver, you can properly retrieve and modify any data in multilingual MySQL databases, regardless of their character set: Latin, Cyrillic, Hebrew, Chinese, etc., and in any language environment.

Features Overview

Secure Connection

Work with MySQL securely using SSL connection options provided in our driver along with the support for SSL protocol. You can also connect to MySQL securely via SSH tunnel. SSH protocol is one of the most reliable protocols for data encryption.

Advanced Data Conversion

We have implemented advanced Data Conversion mechanisms that provide bi-directional mapping between any MySQL and ODBC data types.

Bulk Updates

Moreover, with our driver you can perform bulk updates to MySQL database by combining SQL statements into batches, thus simplifying and speeding up large data modification to MySQL.

Cost-Effective Deployment

Our ODBC driver is a standalone installation file that doesn't require the user to deploy and configure any additional software such as a database client or a vendor library. Deployment costs are reduced drastically, especially when using the silent install method with an OEM license in large organizations that have hundreds of machines.

ODBC Conformance

The driver provides full support for the Microsoft Open Database Connectivity (ODBC) interface, its functions, and data types. It offers advanced connection string parameters and allows any ODBC compliant desktop or web application to connect to MySQL from various environments and platforms.

MySQL Compatibility

Our driver is compatible with the following MySQL versions:

MySQL server: 8.0, 6.0, 5.6, 5.5, 5.1, 5.0, 4.1, 4.0, 3.23
MariaDB server up to 11.x
Microsoft Azure Database for MySQL
Amazon RDS for MySQL, Amazon Aurora
Google Cloud for MySQL

High Performance

Every operation with MySQL becomes significantly faster using such capabilities of our driver as local data caching, connection pooling, and much more.

Support

Visit our Support page to get instant help from knowledgeable and experienced professionals, a quick resolution of your problems, and nightly builds with hotfixes.

Verified Compatibility With Data Integration Tools

Devart ODBC drivers are verified to be compatible with leading analytics and reporting tools, various IDEs and programming languages. Get fast and secure access to your data in any application using our ODBC Drivers!

Database Management Software

Business Intelligence & Analytics Software

Document Management Software

Application Development Tools

Get extra benefits with Devart for Enterprise

Learn more about our convenient software purchasing process and an array of benefits for enterprise companies.

Bonuses for corporate clients
These may include fast and effective deployment, corporate budget optimization, and a number of special deals.

Dedicated manager
We will save your time by providing a dedicated manager to consult you and guide you through all the purchasing and licensing processes.

Learn more

Frequently Asked Questions

What is MySQL connector ODBC?

How to configure an ODBC connection to MySQL database on Windows?

Open the ODBC Data Source Administrator.
Select the User DSN or System DSN tab.
Click Add. The Create New Data Source dialog will appear.
Select Devart ODBC Driver for ODBC Driver for MySQL and click Finish. The driver setup dialog will open.
Enter the connection information in the appropriate fields.
You may test the connectivity by clicking Test Connection.
Click OK to save the DSN.

For detailed instructions on installing and configuring the ODBC driver for PostgreSQL on macOS, please consult the documentation.

What protocol does Devart ODBC Driver for MySQL use?

Devart ODBC driver for MySQL fully supports the SSL protocol so that the connection to the server is secure. Also, the driver supports the SSH protocol and you can connect to MySQL securely via the SSH tunnel.

To choose what protocol you want to use, follow the steps:

Open the Data Source Administrator and go to the Secure Settings tab. Check Use SSL.
To establish an SSL connection to MySQL, specify the SSL certificates and client private key.
To establish an SSH connection to MySQL, specify the connection parameters on the SSH Options tab under Security Settings.
To test the connectivity, click Test Connection. Then Click OK.

For detailed instructions on establishing secure connections to MySQL with ODBC Driver, please consult the documentation.

How to use MySQL Devart ODBC Driver?

The purpose of the ODBC driver for MySQL is to provide a direct and easy connection to the database from application development and programming languages. It allows the user to access MySQL and MariaDB databases from ETL, BI, reporting, and analytics tools directly and safely, without installing any additional packages and libraries.

The driver fully supports ODBC API functions and data types and supports Windows, macOS, and Linux, both 32-bit and 64-bit. Also, the ODBC driver for MySQL is fully compatible with third-party data analysis tools and IDEs, such as Visual Studio. To learn more about the usage of the Devart ODBC driver for MySQL, refer to the documentation.

How to install ODBC driver for MySQL?

The ODBC Driver for MySQL is compatible with Windows, macOS, and Linux platforms, available in both 32-bit and 64-bit versions.

To install the Driver on Windows:

1. Download the appropriate installer for your operating system.
2. Run the downloaded file and follow the setup wizard's instructions.
If a previous version of this Driver is already installed on your computer, you will receive a warning. It is advisable to uninstall the older version completely before installing the new one, rather than simply overwriting the old files.
3. On the Select Components page, choose either the 32-bit or 64-bit version to install.
4. On the License Information page, either activate your existing license or opt for the Trial version. Click Next.
5. Click Install, wait for the installation to complete, then click Finish.

For additional details about installing the Devart ODBC Driver for MySQL on different operating systems, please consult the official documentation.

How to set up ODBC Driver for MySQL?

After installing the driver, create the DSN (Data Source Name) for MySQL in the ODBC Data Source Administrator:

Search for ODBC Data Sources in the Windows search box and select the application that matches the bitness (32-bit or 64-bit) of your third-party application. Alternatively, you can access it via Control Panel > Administrative Tools. For direct access, run C:\Windows\SysWOW64\odbcad32.exe for a 32-bit DSN or C:\Windows\System32\odbcad32.exe for a 64-bit DSN.
Select either the User DSN or System DSN tab. Most applications are compatible with both types, but some may require a specific type.
Click Add to open the Create New Data Source dialog.
Choose the Devart ODBC Driver for MySQL and click Finish. This will open the driver setup dialog. Enter the required connection information in the appropriate fields.
Optionally, click Test Connection to verify connectivity. Click OK to finalize and save the DSN.

For more information about configuring the ODBC Driver for MySQL on different OS platforms, refer to the official documentation.

How to connect ODBC to MariaDB?

Devart ODBC Driver for MySQL is fully compatible with MariaDB. Choose this ODBC driver as the data source when you need to connect to the MariaDB database, specify the connection details, and provide your credentials if necessary. You will connect to the required database immediately.